﻿CREATE TABLE [dbo].[MarketProjectItem] (
    [id]             INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [MID]            INT             NULL,
    [T1]             INT             NULL,
    [T3]             INT             NULL,
    [Supplier]       NVARCHAR (50)   NULL,
    [Contact]        NVARCHAR (30)   NULL,
    [Phone]          NVARCHAR (30)   NULL,
    [UnitPrice]      DECIMAL (18, 2) NULL,
    [Number]         INT             NULL,
    [SpendingTotals] DECIMAL (18, 2) NULL,
    [Person]         NVARCHAR (50)   NULL,
    [Note]           NVARCHAR (500)  NULL,
    [USERID]         VARCHAR (50)    NULL,
    [SaveMark]       INT             NULL,
    [AccountLimit]   DECIMAL (18, 2) NULL,
    [ProfitsItem]    DECIMAL (18, 2) NULL,
    CONSTRAINT [PK_MarketItem] PRIMARY KEY CLUSTERED ([id] ASC)
);

